package pers.kw.server.user.persist.dao;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import pers.kw.server.user.persist.entity.CustUserDO;

public interface CustUserDao extends JpaRepository<CustUserDO, Long> {

    @Query(value = "from CustUserDO where yn=1 and bizCode=:bizCode")
    CustUserDO findByBizCode(@Param("bizCode") String bizCode);


    @Query(value = "from CustUserDO where yn=1 and userNo=:userNo")
    CustUserDO findByUserNo(@Param("userNo") String userNo);

    @Query(value = "from CustUserDO where yn=1 and userName=:userName")
    CustUserDO findByUserName(@Param("userName") String userName);
}
